package com.topgay.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.topgay.domain.Member;
import com.topgay.domain.Message;

public interface MessageDAO {
	
	public abstract Member selectMemberById(String id) throws SQLException;

	public abstract int insertMessage(Message message) throws SQLException;
	
	public abstract List<Member> getMemberList() throws SQLException;
	
	public abstract List<Message> getMessageById(Map map) throws Exception;
	
	public abstract List<Message> getSendMessageById(Map map) throws Exception;
	
	public abstract int selectTotalContent();
	
	public abstract Message selectContentByNum(int num) throws SQLException;
	
	public abstract int deleteMessageByNum(int num) throws SQLException;
	
	public abstract int getTotalMessageNumReceive(String id) throws SQLException;
	
	public abstract int getTotalMessageNumSend(String id) throws SQLException;
}
